namespace Forging2.DataBase.ZH_IMES
{
    using System;
    using System.Collections.Generic;
    using System.ComponentModel.DataAnnotations;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Data.Entity.Spatial;

    public partial class uex_making_order
    {
        [Key]
        [StringLength(50)]
        public string GID { get; set; }

        [StringLength(50)]
        public string CODE { get; set; }

        [StringLength(50)]
        public string WORK_ORDER_CODE { get; set; }

        [StringLength(50)]
        public string MRL_GID { get; set; }

        [StringLength(50)]
        public string MRL_CODE { get; set; }

        [StringLength(100)]
        public string MRL_NAME { get; set; }

        [StringLength(50)]
        public string ORDER_GID { get; set; }

        public int PLAN_QTY { get; set; }

        public int EFFECTIVE_QTY { get; set; }

        public int UNEFFECTIVE_QTY { get; set; }

        public int DISCARD_QTY { get; set; }

        [StringLength(50)]
        public string LAST_WORK_CENTER_GID { get; set; }

        [StringLength(50)]
        public string LAST_WORK_CELL_GID { get; set; }

        [StringLength(50)]
        public string LAST_OP_GID { get; set; }

        public DateTime? LAST_ACQ_DATE { get; set; }

        [StringLength(50)]
        public string QUALITY { get; set; }

        [StringLength(50)]
        public string SPLIT_ID { get; set; }

        public int? QUALITY_STATE { get; set; }

        [StringLength(50)]
        public string LAST_ACQ_EMPLOYEE_GID { get; set; }

        public DateTime? START_DATE { get; set; }

        public DateTime? FINISH_DATE { get; set; }

        public int? STATE { get; set; }

        public int? LAST_SEQ { get; set; }

        [Column(TypeName = "datetime2")]
        public DateTime CREATE_DATE { get; set; }

        [Required]
        [StringLength(32)]
        public string CREATE_ID { get; set; }

        [StringLength(32)]
        public string MODIFY_ID { get; set; }

        [Column(TypeName = "datetime2")]
        public DateTime? MODIFY_DATE { get; set; }

        public int IS_ACTIVE { get; set; }

        public int IS_DELETE { get; set; }

        [StringLength(32)]
        public string SITE { get; set; }

        [StringLength(50)]
        public string UDA1 { get; set; }

        [StringLength(50)]
        public string UDA2 { get; set; }

        [StringLength(50)]
        public string UDA3 { get; set; }

        [StringLength(50)]
        public string UDA4 { get; set; }

        [StringLength(50)]
        public string UDA5 { get; set; }

        [StringLength(100)]
        public string UDA1C { get; set; }

        [StringLength(100)]
        public string UDA1N { get; set; }

        [StringLength(100)]
        public string UDA2C { get; set; }

        [StringLength(100)]
        public string UDA2N { get; set; }

        [StringLength(100)]
        public string UDA3C { get; set; }

        [StringLength(100)]
        public string UDA3N { get; set; }

        [StringLength(100)]
        public string UDA4C { get; set; }

        [StringLength(100)]
        public string UDA4N { get; set; }

        [StringLength(100)]
        public string UDA5C { get; set; }

        [StringLength(100)]
        public string UDA5N { get; set; }

        [StringLength(200)]
        public string REMARK { get; set; }

        [StringLength(200)]
        public string REASON { get; set; }
    }
}
